SQL for IBM I by Rafael Victória-Pereira

Author:Rafael Victória-Pereira [Неизв.]
Language: eng
Format: epub
Publisher: Independent Publishers Group
Published: 2018-07-16T21:00:00+00:00

Easy enough, right? You’ll see examples of RETURN, used in stored procedures, in the next chapter. It makes more sense to show examples of this statement in its proper context.

In This Chapter, You’ve Learned …

This chapter was a bit different from the previous ones, as it introduced a lot of new concepts almost without hands-on practice. It was a necessary approach, in order to explain the SQL/PSM building blocks that will be used in the next few chapters. Here’s a summary of what I’ve covered here:

The concept of data-centric programming, which consists of bringing as much code as possible to near or inside the database, making it easier to “open the database to the outside world,” as the Dean requested

SQL/PSM’s most important statements, namely: Variable declaration and assignment, using DECLARE and SET, respectively

Flow control, resorting to IF and CASE structures

Loop control, with LOOP, WHILE, REPEAT, FOR, and the “bail-out” statements ITERATE and LEAVE

Dynamic SELECT statements, using cursors and the related statements (DECLARE, OPEN, PREPARE, FETCH, and CLOSE)

Other dynamic statements, also using DECLARE and PREPARE, but also EXECUTE and EXECUTE IMMEDIATE

Compound statements, one of the most important concepts in SQL/PSM

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.